# -*- coding: utf-8 -*-
from __future__ import unicode_literals

from django.db import models, migrations


class Migration(migrations.Migration):

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='Feature',
            fields=[
                ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
                ('feature', models.CharField(max_length=200)),
                ('frequency', models.IntegerField()),
                ('category', models.CharField(max_length=200)),
            ],
            options={
                'db_table': 'feature',
            },
        ),
        migrations.CreateModel(
            name='Feature_Score',
            fields=[
                ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
                ('product_id', models.CharField(max_length=200)),
                ('feature', models.CharField(max_length=200)),
                ('score', models.DecimalField(max_digits=10, decimal_places=7)),
                ('num_reviews', models.IntegerField()),
                ('update_date', models.DateField()),
                ('category', models.CharField(max_length=200)),
            ],
            options={
                'db_table': 'score_pf',
            },
        ),
        migrations.CreateModel(
            name='Product',
            fields=[
                ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
                ('product_id', models.CharField(max_length=200)),
                ('name', models.CharField(max_length=200)),
                ('category', models.CharField(max_length=200)),
                ('website', models.CharField(max_length=200)),
                ('brand', models.CharField(max_length=200)),
                ('sale_rank', models.IntegerField()),
                ('avg_rating', models.DecimalField(max_digits=10, decimal_places=5)),
                ('num_reviews', models.IntegerField()),
                ('price', models.DecimalField(max_digits=15, decimal_places=2)),
                ('tags', models.TextField()),
                ('description', models.TextField()),
                ('update_date', models.DateField()),
            ],
            options={
                'db_table': 'product',
            },
        ),
        migrations.CreateModel(
            name='Product_Score',
            fields=[
                ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
                ('product_id', models.CharField(max_length=200)),
                ('score', models.DecimalField(max_digits=10, decimal_places=7)),
                ('update_date', models.DateField()),
                ('category', models.CharField(max_length=200)),
            ],
            options={
                'db_table': 'score_p',
            },
        ),
    ]
